﻿CREATE VIEW [acms].[UserPostUploadFile_View]
AS 
	SELECT 
			a.UserPostUploadId,
			a.[Key],
			a.FileId,
			b.[FileType],
			b.Name,
			b.[Width],
			b.[Height]
	FROM UserPostUploadFiles a
		inner join [acms].[File_View] b on a.FileId = b.Id
;